﻿CREATE PROCEDURE [dbo].[sp_UpdateLocationGeocode]
		@LocationID      INT
	   ,@Latitude        FLOAT
	   ,@Longitude       FLOAT
AS
BEGIN 
	  SET NOCOUNT ON 
	  UPDATE 
		dbo.Location
	  SET
		 longitude = @Longitude
		,latitude  = @Latitude
	  FROM   
		dbo.Location
	  WHERE  
		location_id = @LocationID                   

END